How to count by color and sum by color in Excel 2010 and 2013 A quick way to count cells by color in Excel and get the sum of colored cells in Excel 2013 and 2010. ... Note: If after applying the above mentioned VBA code you would need to color a few more cells manually, the sum and count of the colored cells won't
